﻿<%@ Page Title="" Language="C#" MasterPageFile="~/Store.master" AutoEventWireup="true" CodeFile="SetPrices.aspx.cs" Inherits="SetPrices" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
    <style type="text/css">
        .style2
        {
            width: 248px;
        }
        .style3
        {
        }
        .style5
        {
            text-align: left;
        }
        .style6
        {
            text-align: left;
            width: 96px;
            height: 34px;
        }
        .style7
        {
            text-align: left;
            height: 34px;
        }
        .style9
        {
            text-align: left;
            height: 34px;
            width: 40px;
        }
        .style10
        {
            text-align: left;
            width: 164px;
            height: 34px;
        }
        .style11
        {
            text-align: left;
            height: 34px;
            width: 44px;
        }
        .style12
        {
            text-align: left;
            height: 34px;
            width: 65px;
        }
        .style14
        {
            text-align: left;
            height: 34px;
            width: 62px;
        }
        .style15
        {
            text-align: left;
            height: 34px;
            width: 100px;
        }
        .style16
        {
            text-align: left;
            height: 34px;
            width: 132px;
        }
        .style17
        {
            text-align: left;
            width: 158px;
        }
        .style18
        {
            text-align: left;
            width: 158px;
            height: 34px;
        }
        .style19
        {
            text-align: left;
            width: 96px;
        }
    </style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <p>
        <br />
        <table style="border: 1px solid #000; width:100%;">
            <tr>
                <td class="style3" style="border: 1px solid #000; text-align: left;" 
                    colspan="3">
                    Lenses :</td>
                <td class="style2" style="border: 1px solid #000" colspan="8">
                    &nbsp;</td>
                <td style="border: 1px solid #000; text-align: left;" colspan="5">
                    &nbsp;</td>
            </tr>
            <tr>
                <td class="style6" style="border: 1px solid #000">
                    Brand Name :</td>
                <td class="style18" style="border: 1px solid #000">
                    <asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" 
                        DataSourceID="SqlDataSource1" DataTextField="brandname" 
                        DataValueField="brandname" Width="155px">
                    </asp:DropDownList>
                    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
                        ConnectionString="<%$ ConnectionStrings:nourcenterConnectionString %>" 
                        SelectCommand="SELECT DISTINCT [brandname] FROM [lens] ORDER BY [brandname]">
                    </asp:SqlDataSource>
                </td>
                <td class="style9" style="border: 1px solid #000">
                    Kind :</td>
                <td class="style10" style="border: 1px solid #000" colspan="3">
                    <asp:DropDownList ID="DropDownList3" runat="server" AutoPostBack="True" 
                        Width="155px">
                        <asp:ListItem>Powers</asp:ListItem>
                        <asp:ListItem>Plano</asp:ListItem>
                    </asp:DropDownList>
                </td>
                <td class="style11" style="border: 1px solid #000">
                    Color :</td>
                <td class="style12" style="border: 1px solid #000">
                    <asp:DropDownList ID="DropDownList2" runat="server" AutoPostBack="True" 
                        DataSourceID="SqlDataSource5" DataTextField="color" DataValueField="color" 
                        onselectedindexchanged="DropDownList2_SelectedIndexChanged" Width="155px">
                    </asp:DropDownList>
                    <asp:SqlDataSource ID="SqlDataSource5" runat="server" 
                        ConnectionString="<%$ ConnectionStrings:nourcenterConnectionString %>" 
                        SelectCommand="sp_setcolorpricelens" SelectCommandType="StoredProcedure">
                        <SelectParameters>
                            <asp:ControlParameter ControlID="DropDownList1" Name="brandname" 
                                PropertyName="SelectedValue" Type="String" />
                            <asp:ControlParameter ControlID="DropDownList3" Name="powers" 
                                PropertyName="SelectedValue" Type="String" />
                        </SelectParameters>
                    </asp:SqlDataSource>
                </td>
                <td class="style15" style="border: 1px solid #000">
                    Unite Price :</td>
                <td class="style14" style="border: 1px solid #000">
                    <asp:Label ID="Label1" runat="server"></asp:Label>
                </td>
                <td class="style16" style="border: 1px solid #000">
                    Client Price :</td>
                <td class="style7" style="border: 1px solid #000">
                    <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
                </td>
                <td class="style7" style="border: 1px solid #000">
                    Doctor Price :</td>
                <td class="style7" style="border: 1px solid #000">
                    <asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>
                </td>
                <td class="style7" style="border: 1px solid #000">
                    <asp:Button ID="Button2" runat="server" Height="35px" Text="Show" 
                        Width="71px" onclick="Button2_Click" />
                </td>
                <td class="style7" style="border: 1px solid #000">
                    <asp:Button ID="Button1" runat="server" Height="35px" Text="Update" 
                        Width="71px" onclick="Button1_Click" />
                </td>
            </tr>
            <tr>
                <td class="style3" style="border: 1px solid #000; text-align: left;" 
                    colspan="3">
                    Box :</td>
                <td class="style2" style="border: 1px solid #000; text-align: left;" 
                    colspan="8">
                    &nbsp;</td>
                <td style="border: 1px solid #000; text-align: left;" colspan="5">
                    &nbsp;</td>
            </tr>
            <tr>
                <td class="style19" style="border: 1px solid #000">
                    Brand Name :</td>
                <td class="style17" style="border: 1px solid #000">
                    <asp:DropDownList ID="DropDownList4" runat="server" AutoPostBack="True" 
                        DataSourceID="SqlDataSource2" DataTextField="brandname" 
                        DataValueField="brandname" Width="155px">
                    </asp:DropDownList>
                    <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
                        ConnectionString="<%$ ConnectionStrings:nourcenterConnectionString %>" 
                        SelectCommand="SELECT DISTINCT [brandname] FROM [box] ORDER BY [brandname]">
                    </asp:SqlDataSource>
                </td>
                <td class="style5" style="border: 1px solid #000">
                    Kind :</td>
                <td class="style5" style="border: 1px solid #000">
                    <asp:DropDownList ID="DropDownList5" runat="server" AutoPostBack="True" 
                        Width="155px">
                        <asp:ListItem>Powers</asp:ListItem>
                        <asp:ListItem>Plano</asp:ListItem>
                    </asp:DropDownList>
                </td>
                <td class="style5" style="border: 1px solid #000">
                    Pck :</td>
                <td class="style5" style="border: 1px solid #000">
                    <asp:DropDownList ID="DropDownList10" runat="server" Height="22px" Width="80px" 
                        AutoPostBack="True" DataSourceID="SqlDataSource3" DataTextField="pck" 
                        DataValueField="pck">
                    </asp:DropDownList>
                    <asp:SqlDataSource ID="SqlDataSource3" runat="server" 
                        ConnectionString="<%$ ConnectionStrings:nourcenterConnectionString %>" 
                        SelectCommand="sp_setpckpricebox" SelectCommandType="StoredProcedure">
                        <SelectParameters>
                            <asp:ControlParameter ControlID="DropDownList4" Name="brandname" 
                                PropertyName="SelectedValue" Type="String" />
                            <asp:ControlParameter ControlID="DropDownList5" Name="powers" 
                                PropertyName="SelectedValue" Type="String" />
                        </SelectParameters>
                    </asp:SqlDataSource>
                </td>
                <td class="style5" style="border: 1px solid #000">
                    Color :</td>
                <td class="style5" style="border: 1px solid #000">
                    <asp:DropDownList ID="DropDownList6" runat="server" AutoPostBack="True" 
                        Width="155px" DataSourceID="SqlDataSource4" DataTextField="color" 
                        DataValueField="color">
                    </asp:DropDownList>
                    <asp:SqlDataSource ID="SqlDataSource4" runat="server" 
                        ConnectionString="<%$ ConnectionStrings:nourcenterConnectionString %>" 
                        SelectCommand="sp_setcolorpricebox" SelectCommandType="StoredProcedure">
                        <SelectParameters>
                            <asp:ControlParameter ControlID="DropDownList4" Name="brandname" 
                                PropertyName="SelectedValue" Type="String" />
                            <asp:ControlParameter ControlID="DropDownList10" Name="pck" 
                                PropertyName="SelectedValue" Type="Int32" />
                            <asp:ControlParameter ControlID="DropDownList5" Name="powers" 
                                PropertyName="SelectedValue" Type="String" />
                        </SelectParameters>
                    </asp:SqlDataSource>
                </td>
                <td class="style5" style="border: 1px solid #000">
                    Unite Price :</td>
                <td class="style5" style="border: 1px solid #000">
                    <asp:Label ID="Label2" runat="server"></asp:Label>
                </td>
                <td class="style5" style="border: 1px solid #000">
                    Client Price :</td>
                <td class="style5" style="border: 1px solid #000">
                    <asp:TextBox ID="TextBox3" runat="server"></asp:TextBox>
                </td>
                <td class="style5" style="border: 1px solid #000">
                    Doctor Price :</td>
                <td class="style5" style="border: 1px solid #000">
                    <asp:TextBox ID="TextBox4" runat="server"></asp:TextBox>
                </td>
                <td class="style5" style="border: 1px solid #000">
                    <asp:Button ID="Button3" runat="server" Height="35px" Text="Show" 
                        Width="71px" onclick="Button3_Click" />
                </td>
                <td class="style5" style="border: 1px solid #000">
                    <asp:Button ID="Button4" runat="server" Height="35px" Text="Update" 
                        Width="71px" onclick="Button4_Click" />
                </td>
            </tr>
            <tr>
                <td class="style3" style="border: 1px solid #000; text-align: left;" 
                    colspan="3">
                    Solutions :</td>
                <td class="style2" style="border: 1px solid #000" colspan="8">
                    &nbsp;</td>
                <td style="border: 1px solid #000; text-align: left;" colspan="5">
                    &nbsp;</td>
            </tr>
            <tr>
                <td class="style19" style="border: 1px solid #000">
                    Name :</td>
                <td class="style5" style="border: 1px solid #000">
                    <asp:DropDownList ID="DropDownList7" runat="server" Width="155px" 
                        AutoPostBack="True" DataSourceID="SqlDataSource6" DataTextField="brandname" 
                        DataValueField="brandname">
                    </asp:DropDownList>
                    <asp:SqlDataSource ID="SqlDataSource6" runat="server" 
                        ConnectionString="<%$ ConnectionStrings:nourcenterConnectionString %>" 
                        SelectCommand="SELECT DISTINCT [brandname] FROM [soln] ORDER BY [brandname]">
                    </asp:SqlDataSource>
                </td>
                <td class="style5" style="border: 1px solid #000">
                    Bottle Size :</td>
                <td class="style5" colspan="3" style="border: 1px solid #000">
                    <asp:DropDownList ID="DropDownList8" runat="server" Width="155px" 
                        AutoPostBack="True" DataSourceID="SqlDataSource7" DataTextField="bottlesize" 
                        DataValueField="bottlesize">
                    </asp:DropDownList>
                    <asp:SqlDataSource ID="SqlDataSource7" runat="server" 
                        ConnectionString="<%$ ConnectionStrings:nourcenterConnectionString %>" 
                        SelectCommand="SELECT DISTINCT [bottlesize] FROM [soln] WHERE ([brandname] = @brandname)">
                        <SelectParameters>
                            <asp:ControlParameter ControlID="DropDownList7" Name="brandname" 
                                PropertyName="SelectedValue" Type="String" />
                        </SelectParameters>
                    </asp:SqlDataSource>
                </td>
                <td class="style5" style="border: 1px solid #000">
                    Unite Price :</td>
                <td class="style5" style="border: 1px solid #000">
                    <asp:Label ID="Label3" runat="server"></asp:Label>
                </td>
                <td class="style5" style="border: 1px solid #000">
                    Client Price :</td>
                <td class="style5" style="border: 1px solid #000">
                    <asp:TextBox ID="TextBox5" runat="server"></asp:TextBox>
                </td>
                <td class="style5" style="border: 1px solid #000">
                    Doctor Price :</td>
                <td class="style5" style="border: 1px solid #000">
                    <asp:TextBox ID="TextBox6" runat="server"></asp:TextBox>
                </td>
                <td class="style5" style="border: 1px solid #000">
                    <asp:Button ID="Button5" runat="server" Height="35px" Text="Show" 
                        Width="71px" onclick="Button5_Click" />
                </td>
                <td class="style5" colspan="2" style="border: 1px solid #000">
                    <asp:Button ID="Button6" runat="server" Height="35px" Text="Update" 
                        Width="71px" onclick="Button6_Click" />
                </td>
                <td class="style5" style="border: 1px solid #000">
                    &nbsp;</td>
            </tr>
            <tr>
                <td class="style3" style="border: 1px solid #000; text-align: left;" 
                    colspan="3">
                    Accessories :</td>
                <td class="style2" style="border: 1px solid #000" colspan="8">
                    &nbsp;</td>
                <td style="border: 1px solid #000; text-align: left;" colspan="5">
                    &nbsp;</td>
            </tr>
            <tr>
                <td class="style3" 
                    style="border: 1px solid #000; text-align: left;">
                    Name :</td>
                <td class="style3" 
                    style="border: 1px solid #000; text-align: left;">
                    <asp:DropDownList ID="DropDownList9" runat="server" Width="155px" 
                        AutoPostBack="True" DataSourceID="SqlDataSource8" DataTextField="name" 
                        DataValueField="name">
                    </asp:DropDownList>
                    <asp:SqlDataSource ID="SqlDataSource8" runat="server" 
                        ConnectionString="<%$ ConnectionStrings:nourcenterConnectionString %>" 
                        SelectCommand="SELECT [name] FROM [accs] ORDER BY [name]">
                    </asp:SqlDataSource>
                </td>
                <td class="style3" 
                    style="border: 1px solid #000; text-align: left;">
                    Unite Price :</td>
                <td class="style3" colspan="3" 
                    style="border: 1px solid #000; text-align: left;">
                    <asp:Label ID="Label4" runat="server"></asp:Label>
                </td>
                <td class="style3" 
                    style="border: 1px solid #000; text-align: left;">
                    Client Price :</td>
                <td class="style3" 
                    style="border: 1px solid #000; text-align: left;">
                    <asp:TextBox ID="TextBox7" runat="server"></asp:TextBox>
                </td>
                <td class="style3" 
                    style="border: 1px solid #000; text-align: left;">
                    Doctor Price :</td>
                <td class="style3" 
                    style="border: 1px solid #000; text-align: left;">
                    <asp:TextBox ID="TextBox8" runat="server"></asp:TextBox>
                </td>
                <td class="style3" 
                    style="border: 1px solid #000; text-align: left;">
                    <asp:Button ID="Button7" runat="server" Height="35px" Text="Show" 
                        Width="71px" onclick="Button7_Click" />
                </td>
                <td class="style3" 
                    style="border: 1px solid #000; text-align: left;">
                    <asp:Button ID="Button8" runat="server" Height="35px" Text="Update" 
                        Width="71px" onclick="Button8_Click" />
                </td>
                <td class="style3" 
                    style="border: 1px solid #000; text-align: left;">
                    &nbsp;</td>
                <td class="style3" colspan="2" 
                    style="border: 1px solid #000; text-align: left;">
                    &nbsp;</td>
                <td class="style3" 
                    style="border: 1px solid #000; text-align: left;">
                    &nbsp;</td>
            </tr>
        </table>
        
    </p>
    <table style="width:100%;">
        <tr>
            <td>
                &nbsp;</td>
            <td>
                &nbsp;</td>
            <td>
                &nbsp;</td>
        </tr>
        <tr>
            <td>
                &nbsp;</td>
            <td>
                &nbsp;</td>
            <td>
                &nbsp;</td>
        </tr>
        <tr>
            <td>
                &nbsp;</td>
            <td>
                &nbsp;</td>
            <td>
                &nbsp;</td>
        </tr>
    </table>
</asp:Content>

